UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e+rGI8UtBZh+VHu7nffU5YYmTo6en+LeOywiAADlLNA='
WHERE
key_id = 'c028470b438a9c1aadfcf2bc95353bcb47efb357ed1740f6137dff0842d84ebc'
AND (
token = 'e+rGI8UtBZh+VHu7nffU5YYmTo6en+LeOywiAADlLNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)