UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XzYpKB4u7dmaRoPXfb1ZQFPf4oszI5J+i43Ia9txkIE='
WHERE
key_id = 'fe9cf58711880caa07e863c21536b5401d306ec46156bc91818e5b877a86989e'
AND (
token = 'XzYpKB4u7dmaRoPXfb1ZQFPf4oszI5J+i43Ia9txkIE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)