UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HgUTmfHScQJ1SXvt0pGrb/8d5V0xnkARiH58nFFSI8Y='
WHERE
key_id = 'ff02f69f158a9b4abdc0d8a167dda91dee67c2a46d3f206fc47e763fa881373d'
AND (
token = 'HgUTmfHScQJ1SXvt0pGrb/8d5V0xnkARiH58nFFSI8Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)