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