UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hW0bZnjq+Q18N3IIa5NzKqjH1ZiA/D3KnbFNOsLum/U='
WHERE
key_id = '23a19e074be64b43b677ebb025b01b3ced44e1cb464deffe5a3ac5894af5a6e0'
AND (
token = 'hW0bZnjq+Q18N3IIa5NzKqjH1ZiA/D3KnbFNOsLum/U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)