UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eRIk3t1rPYGHUhjqQavoBIoTv5XKeALXKE6XU9V2Crs='
WHERE
key_id = '8a5e871fbe5bf1838fd6c4f04e4f2e79ab1cc3a5d23ffa10511dd0b0db5292d4'
AND (
token = 'eRIk3t1rPYGHUhjqQavoBIoTv5XKeALXKE6XU9V2Crs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)