UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IXw4NnPztZR7HVmQyOlx9SSH6tLiopGIs3eywbxfZkM='
WHERE
key_id = '05d499649a02e7c34082ab67ca1086152e75f37295f5ccb411ea0a983086d224'
AND (
token = 'IXw4NnPztZR7HVmQyOlx9SSH6tLiopGIs3eywbxfZkM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)