UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5w46wYu12+2XYDXPkuhFzY8caMYkQFm5zGy8Gyv0fO0='
WHERE
key_id = '469301f43d831d81fd848aae0a64e4ec4a5840446f12456b435c8fbba5d16bcc'
AND (
token = '5w46wYu12+2XYDXPkuhFzY8caMYkQFm5zGy8Gyv0fO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)