UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'rA78u+J+KyVyRtlyY0d/Wpc2OUGMY3YdNRutVRyjlHE='
WHERE
key_id = 'f0184aa383baa154224e1f0307a0ad923bdd16927dcd12f8b719351e21c7841d'
AND (
token = 'rA78u+J+KyVyRtlyY0d/Wpc2OUGMY3YdNRutVRyjlHE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)