UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xe0ZMhqzRsL+MRD6/9L0Izl8Ppkm4V83uvKkP6h5Crg='
WHERE
key_id = '9e9fcb5623a9c16581e8bc96dec60320a6b985defcb9ea4d1cd5b7760fb7a65d'
AND (
token = 'Xe0ZMhqzRsL+MRD6/9L0Izl8Ppkm4V83uvKkP6h5Crg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)