UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ygnyqztmKAZNNdaZw+b5v49p6gUMfMrIWEkIyGnw7sw='
WHERE
key_id = 'f9ac18503f1699d36b40a6b2705e12dfc8586a9a13502d0097fd33ea59096879'
AND (
token = 'ygnyqztmKAZNNdaZw+b5v49p6gUMfMrIWEkIyGnw7sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)