UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sXbtNf9BpVKkMdg2X/HIKxa04KhH9qFmYPeBEUi5U54='
WHERE
key_id = '692626277d567b095843b418d2325ee9398819b088f3651b131abe77bd38c786'
AND (
token = 'sXbtNf9BpVKkMdg2X/HIKxa04KhH9qFmYPeBEUi5U54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)