UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xvDgEH2BI5iK7M3EEu7dhvpnJeVrkJS4oLbSogeXyn8='
WHERE
key_id = '18278ce46d81065b4f88a0f4ba4d57afc3b3f5d92bb992ba5bab575f1dd8b514'
AND (
token = 'xvDgEH2BI5iK7M3EEu7dhvpnJeVrkJS4oLbSogeXyn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)