UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zC8c4cuDKyREgL+FkfKLC21J1egS96FA0/7RhmkKmPo='
WHERE
key_id = '84c8d2d240b8f1c61d490970c8dd33b239d43529f477469ee397c3c7e857c120'
AND (
token = 'zC8c4cuDKyREgL+FkfKLC21J1egS96FA0/7RhmkKmPo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)