UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ckYAX0AmmZHvJB5/BPixjD2qozlhcz6CZDrdhgl7+lw='
WHERE
key_id = 'a580e55de8295dbc4f0b46cb509c4dec0219ca83d70175c1477294f3759a4232'
AND (
token = 'ckYAX0AmmZHvJB5/BPixjD2qozlhcz6CZDrdhgl7+lw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)