UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qC8kjl4Ytoqc0nw+Ks3jf0CwF6lYFNfv2nY7A2adk58='
WHERE
key_id = 'acfd6fdb95815a26f3e83ef2df86fca140a823e21b708e95f7535525be13f9bd'
AND (
token = 'qC8kjl4Ytoqc0nw+Ks3jf0CwF6lYFNfv2nY7A2adk58='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)