UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6cyXiEAvOjVhGhfRvtLnyC+Ggho07W9r77bhdPHeA1Y='
WHERE
key_id = 'd607b933665400eeadd218f91549b5fc5f604f5b87e001ff7b672d19e611f8c2'
AND (
token = '6cyXiEAvOjVhGhfRvtLnyC+Ggho07W9r77bhdPHeA1Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)