UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RShv9p9S/7Um8o2lAzk2RD3AFlhXmAazhDpITpTDnsM='
WHERE
key_id = 'bb9e9bb670316f824f0a7e11d14b5d74078a0f5cc1b5fef4651032e43bb11969'
AND (
token = 'RShv9p9S/7Um8o2lAzk2RD3AFlhXmAazhDpITpTDnsM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)