UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JZrLwhJK4PXBPZ5VyYZdb2TWYADfBSeXnR4hiFPUKr0='
WHERE
key_id = 'de24e0b2e8f5fbd7b148a5c60cac0ad5c5b677786f19e9860e2ffa386d1a9ed8'
AND (
token = 'JZrLwhJK4PXBPZ5VyYZdb2TWYADfBSeXnR4hiFPUKr0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)