UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'I8ZZtyYC1shjWnLTvudRxztAVyOhNKLOT8840hBapXc='
WHERE
key_id = 'ef80099f92a4ef145a991fca2f331f49417a19b1956c1c23f17c964ee9e76710'
AND (
token = 'I8ZZtyYC1shjWnLTvudRxztAVyOhNKLOT8840hBapXc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)