UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd9JcKoDqj7/NqRpRXSCsVvpYaO0O1bsOstt9dL/lXmg='
WHERE
key_id = '7b55fdc4877a147415b034c9650f5c995b9931c9135b691f5b8397dd9c700c1f'
AND (
token = 'd9JcKoDqj7/NqRpRXSCsVvpYaO0O1bsOstt9dL/lXmg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)