UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '87XklV1gqU7zktJJcG7ZoAdQ7NSpUGRi74K8WE0XBK4='
WHERE
key_id = '32b3e18bd2df8847dd81c585082dff1e2ab275128c421fc7316daa5a9dac5c7c'
AND (
token = '87XklV1gqU7zktJJcG7ZoAdQ7NSpUGRi74K8WE0XBK4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)