UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qGNP8ag7sMzduzZL/M/EzjkhK8JfHydHtmhOZkHurpw='
WHERE
key_id = 'bc9b9847d6dd1535b563769a010e24cfa69f0b317267dca1d1eb0570854d476f'
AND (
token = 'qGNP8ag7sMzduzZL/M/EzjkhK8JfHydHtmhOZkHurpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)