UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nSin1CQqIzr8mVAEQc0hV+yILRCy+VtzC7l+rBZ4J7U='
WHERE
key_id = '8f349d9c1d266af3d5972ded7b678a353868bafbda55f96928ea69c1d12b1830'
AND (
token = 'nSin1CQqIzr8mVAEQc0hV+yILRCy+VtzC7l+rBZ4J7U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)