UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Koubuu6PesWWIrT2iANUQ0ULD9MfGLFWub8CA63q87Y='
WHERE
key_id = 'e100c79e73458c8b8393e264c8f1585053db6fd09a153387457df79a95eea8dd'
AND (
token = 'Koubuu6PesWWIrT2iANUQ0ULD9MfGLFWub8CA63q87Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)