UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9k/aRzj8IH/dsS6OmRYySXezghqwM85CQ0m35xLy9eE='
WHERE
key_id = '78ce8ef5165a5534f16bb452f78f16952f8415401c1d8a55f76902203daac5b9'
AND (
token = '9k/aRzj8IH/dsS6OmRYySXezghqwM85CQ0m35xLy9eE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)