UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n59xsLww8LwRJ4aN8VLoADwFRBbTm1aPPsD5oX/5N/M='
WHERE
key_id = 'a5f02c1146bf08747cee9ed91980f39208f822734880e8a1cd657c8e408205de'
AND (
token = 'n59xsLww8LwRJ4aN8VLoADwFRBbTm1aPPsD5oX/5N/M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)