UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pqlvz29MsDn4cVwDmaap/PO+6w4CTF1KVbuVGC2Skrc='
WHERE
key_id = '3fb7a5cc4c6bb17f8133c258b5c9da2e2e74d8655202fecb1d4088724bcc23c5'
AND (
token = 'pqlvz29MsDn4cVwDmaap/PO+6w4CTF1KVbuVGC2Skrc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)