UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'N7K6fXI5peDc3D81S3mgngpcMWDpI3rvRNh/I8unKso='
WHERE
key_id = 'ca8bc8a36a480d0c827f79175b07e18c8134199716d58f6a37970ff8bcea8acd'
AND (
token = 'N7K6fXI5peDc3D81S3mgngpcMWDpI3rvRNh/I8unKso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)