UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eHxfx56LggTeG0NDlpbypn2SnjVNa3bJIAt6cjfS3nM='
WHERE
key_id = '56aff570ebbb62d9d95e7ebebcd0d759baf842871ed721bc53f262b98fa13fb0'
AND (
token = 'eHxfx56LggTeG0NDlpbypn2SnjVNa3bJIAt6cjfS3nM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)