UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9pCfeWOxf5KnK17NBJDiTuhMpn1MLvYfSaX9Ke1fFLo='
WHERE
key_id = 'c18449ae7d37990f208d3012fb9df285fd6e6c75efd6d2aa809934d1206d604d'
AND (
token = '9pCfeWOxf5KnK17NBJDiTuhMpn1MLvYfSaX9Ke1fFLo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)