UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VzDqqoQlPLL2bMv8EN8eM1f5O6HN0yEhNJKnTl5RAkw='
WHERE
key_id = 'd0cae20b4cdf6538a9504262e91a5b2e2ea8c5a9728236ed756cd472e55fdae2'
AND (
token = 'VzDqqoQlPLL2bMv8EN8eM1f5O6HN0yEhNJKnTl5RAkw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)