UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hjlmCBbqBH7DhiZfOxyK2q4WpW59cjvttAyJixqWfeg='
WHERE
key_id = '2b191db9601171a530f311cbd7ed87c6999c8184e2e390b5a157ea731c048a06'
AND (
token = 'hjlmCBbqBH7DhiZfOxyK2q4WpW59cjvttAyJixqWfeg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)