UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hXwGP1Wrg6+HJOjOIh+DBhwbvcbukFYNL056eNcb6U4='
WHERE
key_id = '0fa6f20d2597be8bba2ac55500d89540d34eaea31e73303bc1f7b8b039a36d64'
AND (
token = 'hXwGP1Wrg6+HJOjOIh+DBhwbvcbukFYNL056eNcb6U4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)