UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'c+vYdrBbDWhNIL6D/i7s7QPC531vtzA9RI53oaUG1x4='
WHERE
key_id = '1e47b055451092d817eb62d3b097247d931ebb868dddba27a6bd038ad929f0db'
AND (
token = 'c+vYdrBbDWhNIL6D/i7s7QPC531vtzA9RI53oaUG1x4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)