UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8DQa2HUdmYAw1ViNsuxLigCBHMpkw0t0zZd3cv73TSI='
WHERE
key_id = 'a89c71db711fe445453399414da4810d6970b826623aa82b6b13b122fdf68351'
AND (
token = '8DQa2HUdmYAw1ViNsuxLigCBHMpkw0t0zZd3cv73TSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)