UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZVk4NvLRRC4i3mlscdSz2nxEFGIh0DuFpgXN4aqivV0='
WHERE
key_id = '5a716e83ff5d58087a653f6039c6d72edf9dba92cc94ca5294c1a57ec720a8ed'
AND (
token = 'ZVk4NvLRRC4i3mlscdSz2nxEFGIh0DuFpgXN4aqivV0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)