UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0DZ24YgmSwqkeWPapGW/iKTxBq95vD1X32ZpiFqadqY='
WHERE
key_id = 'ca620ff66201d665a7218152c11d6e0c570a1e59120d2731e377bd865c2e6831'
AND (
token = '0DZ24YgmSwqkeWPapGW/iKTxBq95vD1X32ZpiFqadqY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)