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