UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Wl4Q5t7v8C8iqokrH+xfepm2JKdgFElTSm/6MAROcLA='
WHERE
key_id = '0ffea74cfc980ebf4e80269550b137bc7d97c0d60edc77284c45316daae29778'
AND (
token = 'Wl4Q5t7v8C8iqokrH+xfepm2JKdgFElTSm/6MAROcLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)