UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '50jQRIgwjncwqfuXu6U1r88eFoz3nRluqaMNs7use7o='
WHERE
key_id = '693b948f088c51e643f1d4a47cf2e5b3b127ac7b6f1b2d3c1c8e3c844c5d9bb2'
AND (
token = '50jQRIgwjncwqfuXu6U1r88eFoz3nRluqaMNs7use7o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)